When using ADO.NET there are a few critical resources that should be used with care from an application. These are

• Connections
• Commands
• Transactions

Each of these allocate resources in the Mimer SQL database server and should thus be closed properly to avoid leaking resources unnecessarily in the server. In this chapter we will take a look explicitly at transactions and how these are managed.

A number of strategies and coding templates exist to help work with transactions using

• Auto-commit mode
• Explicit transactions by starting and then subsequently committing or rolling back the transaction.

In the following sections these modes are discussed and code examples are shown.